
use common
GO
if exists (select 1 from sysobjects where name ='p_GetRepoDetails')
begin
        drop proc p_GetRepoDetails
    	IF OBJECT_ID('dbo.p_GetRepoDetails') IS NOT NULL
        	PRINT '<<< FAILED DROPPING PROCEDURE dbo.p_GetRepoDetails >>>'
    	ELSE
        	PRINT '<<< DROPPED PROCEDURE dbo.p_GetRepoDetails >>>'
end
GO
create proc p_GetRepoDetails  
as 
begin 
  select * from common..t_Repo
  end 
return 0 
GO
grant execute on p_GetRepoDetails to public
GO
IF OBJECT_ID('dbo.p_GetRepoDetails') IS NOT NULL
    PRINT '<<< CREATED PROCEDURE dbo.p_GetRepoDetails >>>'
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.p_GetRepoDetails >>>'
GO